package iwpl.project.servlet;

import iwpl.project.dao.OfficesDAO;
import iwpl.project.entities.Departments;
import iwpl.project.entities.Offices;
import iwpl.project.entitymanagerhelper.*;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Control_Office extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public Control_Office() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	public static void ExecuteControl(String Control, Offices Offi) {
		OfficesDAO dao = new OfficesDAO();

		if (Control == "Save") {
			EntityManagerHelper.beginTransaction();
			dao.save(Offi);
			EntityManagerHelper.commit();
		}

		if (Control == "Update") {
			EntityManagerHelper.beginTransaction();
			dao.update(Offi);
			EntityManagerHelper.commit();
		}

		if (Control == "Delete") {
			EntityManagerHelper.beginTransaction();
			dao.delete(Offi);
			EntityManagerHelper.commit();
		}
	}

	/**
	 * The doGet method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		/*
		 * response.setContentType("text/html"); PrintWriter out =
		 * response.getWriter(); out.println(
		 * "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		 * out.println("<HTML>");
		 * out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
		 * out.println("  <BODY>"); out.print("    This is ");
		 * out.print(this.getClass()); out.println(", using the GET method");
		 * out.println("  </BODY>"); out.println("</HTML>"); out.flush();
		 * out.close();
		 */
		doProcess(request, response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to
	 * post.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		/*
		 * response.setContentType("text/html"); PrintWriter out =
		 * response.getWriter(); out.println(
		 * "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		 * out.println("<HTML>");
		 * out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
		 * out.println("  <BODY>"); out.print("    This is ");
		 * out.print(this.getClass()); out.println(", using the POST method");
		 * out.println("  </BODY>"); out.println("</HTML>"); out.flush();
		 * out.close();
		 */

		doProcess(request, response);
	}

	public void doProcess(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {

		Offices Offi = new Offices();

		String strOfficeID = request.getParameter("TxtOfficeID");
		String strOffiID = request.getParameter("OfficeID");
		String strDepartmentID = request.getParameter("CboDepartmentID");
		String strOfficeName = request.getParameter("TxtOfficeName");
		String strPhone = request.getParameter("TxtPhone");
		String strAddress = request.getParameter("TxtAddress");

		String strStatusSave = request.getParameter("BtnSave");
		String strStatusUpdate = request.getParameter("BtnUpdate");
		String strStatusDelete = request.getParameter("delete");

		Departments depart = new Departments();
		if (strDepartmentID != null)
			depart.setId(Integer.parseInt(strDepartmentID));

		if (strStatusSave != null) {
			Offi.setOfficeName(strOfficeName);
			Offi.setDepartments(depart);
			Offi.setAddress(strAddress);
			Offi.setPhone(strPhone);

			ExecuteControl("Save", Offi);
			// After run command, return main page
			response.sendRedirect("/DepartmentManage/Manage_Offices.jsp");
		}

		if (strStatusDelete != null) {
			Offi.setId(Integer.parseInt(strStatusDelete));
			ExecuteControl("Delete", Offi);
			// After run command, return main page
			response.sendRedirect("/DepartmentManage/Manage_Offices.jsp");
		}

		if (strStatusUpdate != null) {
			Offi.setId(Integer.parseInt(strOffiID));
			Offi.setOfficeName(strOfficeName);
			Offi.setDepartments(depart);
			Offi.setAddress(strAddress);
			Offi.setPhone(strPhone);

			ExecuteControl("Update", Offi);
			// After run command, return main page
			response.sendRedirect("/DepartmentManage/Manage_Offices.jsp");
		}

	}

	/**
	 * Initialization of the servlet. <br>
	 * 
	 * @throws ServletException
	 *             if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}
